<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN">
<html>
<head>
<title>From clause</title>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <meta name="generator" content="Doc-O-Matic" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <link rel="STYLESHEET" href="default.css" type="text/css" />

<script type="text/javascript" src="scripts.js"></script>
</head>
<body class="Element700" onload="onBodyLoadEx('frames.html', 'topic', 'From_clause.html');" onmousedown="onBodyMouseDown();">

<!-- Begin Popups -->

<!-- End Popups -->

<!-- Begin Page Header -->
<div class="Element710" id="areafixed">
<div class="Element94">
<em>You are here:</em> Using General SQL Parser &gt; <a href="Select_Statement.html" target="topic">Select Statement</a> &gt; <a href="From_clause.html" target="topic">From clause</a></div>
<div class="Element92">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="50%">
<div class="Element2">
<a href="contents.html" target="tocidx"><img src="btn_globals_contents_midblue.gif" border="0" alt="Contents" title="Contents" onmouseover="switchImage(this, 'btn_globals_contents_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_contents_midblue.gif');"></a><a href="idx.html" target="tocidx"><img src="btn_globals_index_midblue.gif" border="0" alt="Index" title="Index" onmouseover="switchImage(this, 'btn_globals_index_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_index_midblue.gif');"></a><a href="index.html" target="topic"><img src="btn_globals_home_midblue.gif" border="0" alt="Home" title="Home" onmouseover="switchImage(this, 'btn_globals_home_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_globals_home_midblue.gif');"></a></div>
</td><td width="50%">
<div class="Element90">
<a href="Select_Statement.html" target="topic"><img src="btn_prev_midblue.gif" border="0" alt="Previous" title="Previous" onmouseover="switchImage(this, 'btn_prev_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_prev_midblue.gif');"></a><a href="Select_Statement.html" target="topic"><img src="btn_up_midblue.gif" border="0" alt="Up" title="Up" onmouseover="switchImage(this, 'btn_up_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_up_midblue.gif');"></a><a href="Select_list.html" target="topic"><img src="btn_next_midblue.gif" border="0" alt="Next" title="Next" onmouseover="switchImage(this, 'btn_next_midblue_hover.gif');" onmouseout="switchImage(this, 'btn_next_midblue.gif');"></a></div>
</td></tr></table><div class="Element5">
From clause</div>
</div>
</div>

<!-- End Page Header -->

<!-- Begin Client Area -->
<div class="Element720" id="areascroll">
<div class="Element721">

<!-- Begin Page Content -->
<div class="Element58">
<a name="Description"></a><div class="Element11">
<div class="Element10">
<p class="Element10">
From clause in select statement was represented by JoinTables which is type of <a href="TLzJoinList.html" target="topic">TLzJoinList</a>.&nbsp;</p>
<p class="Element10">
For more detailed information about join table in from clause, you can check <a href="How_to_use_join_table.html" target="topic">&quot;how to use join table&quot;</a>.&nbsp;</p>
<p class="Element10">
JoinTables represents from clause in a hierarchy structure which includes all information in from clause such as join table, join type and join condition, if you only need to fetch table information in from clause, you can use tables instead which is type of <a href="TLzTableList.html" target="topic">TLzTableList</a>.&nbsp;</p>
<p class="Element10">
&nbsp;</p>
<p class="Element10">
Here are some key properties of <a href="TLzTable.html" target="topic">TLzTable</a>:
<ol class="Element633">
<li value="1" class="Element603">TableName, fetch table name or set table name to new value by using this property.</li>
<li value="2" class="Element603">TablePrefix, fetch table owner or set table owner to new value by using this property.</li>
<li value="3" class="Element603">TableType, is type of TLzTableType,
<ul class="Element634">
<li class="Element604">lttAttr, it's a ordinary table, use TableAttr to fetch more information.</li>
<li class="Element604">lttFunc, it's a function derived table, use TableFunc to fetch more information.</li>
<li class="Element604">lttExpr, it's an expression that represents a table, use TableExpr to fetch more information.</li>
<li class="Element604">lttSubquery, it's a subquery table, use Subquery to fetch more information.</li>
</ul></li>
</ol>4. TableAlias, fetch or set table alias string value.&nbsp;</p>
<p class="Element10">
5. AliasClause, which is type of <a href="TLz_AliasClause.html" target="topic">TLz_AliasClause</a>, you can get more detailed information about table alias using this property.&nbsp;</p>
<p class="Element10">
&nbsp;</p>
<p class="Element10">
You can use FromClauseText to get string representation of all from clause. Set FromClauseText to a new string value will set whole from clause.&nbsp;</p>
<p class="Element10">
&nbsp;</p>
<p class="Element10">
You can check following demos shipped together with this component to find out more information about how to work with joins in from clause:
<ol class="Element633">
<li value="1" class="Element603">jointabledetail</li>
<li value="2" class="Element603">jointablerelation</li>
<li value="3" class="Element603">joinconverter</li>
</ol>4. tablefieldrel</p></div>
</div>
</div>
<!-- End Page Content -->

<!-- Begin Page Footer -->
<div class="Element93">
<table width="100%" cellspacing="0" cellpadding="0">
<tr><td width="100%">
<div class="Element3">
Gudu software http://www.sqlparser.com</div>
</td></tr><tr><td width="100%">
<div class="Element97">
Send <a href="#" onclick="sendFeedback('info@sqlparser.com', 'Documentation Feedback', 'Project: General SQL Parser Help file%0ATopic ID: From clause%0ATitle: From clause');">comments</a> about this topic.</div>
</td></tr></table></div>

<!-- End Page Footer -->
</div>
</div>

<!-- End Client Area -->
</body></html>